To Create a Feature of Type GeoRaster

Create the table with one geometry column and one ID.

CREATE TABLE TORONTO (ID NUMBER PRIMARY KEY, ImageName VARCHAR2(256), Raster SDO_GEORASTER);

Create the raster data table.

CREATE TABLE TORONTO_RDT OF SDO_RASTER 
(PRIMARY KEY(RasterID, PyramidLevel, BandBlockNumber, RowBlockNumber, ColumnBlockNumber);

Import the raster data.

Insert the table metadata in the Oracle Spatial metadata.

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) 
VALUES ('TORONTO', 'Raster.SpatialExtent, MDSYS.SDO_DIM_ARRAY (
MDSYS.SDO_DIM_ELEMENT('X', 310630.031200000, 314302.525626524, 0.000000050), 
MDYS.SDO_DIM_ELEMENT('Y', 4832370.186944857, 4835182.257600000, 0.000000050) ), 
2019);

Create the spatial index of type multipolygon to use model multi-geometry objects.

CREATE INDEX TORONTO_IDX ON TORONTO (Raster.SpatialExtent) 
INDEXTYPE IS MDSYS.SPATIAL_INDEX_V2;